CREATE TABLE [dbo].[DnnProduct_ModuleSettings]
(
[ModuleID] [int] NOT NULL,
[SettingName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SettingValue] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedByUserID] [int] NULL,
[CreatedOnDate] [datetime] NULL,
[LastModifiedByUserID] [int] NULL,
[LastModifiedOnDate] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_ModuleSettings] ADD CONSTRAINT [PK_DnnProduct_ModuleSettings] PRIMARY KEY CLUSTERED  ([ModuleID], [SettingName]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_ModuleSettings] WITH NOCHECK ADD CONSTRAINT [FK_DnnProduct_ModuleSettings_DnnProduct_Modules] FOREIGN KEY ([ModuleID]) REFERENCES [dbo].[DnnProduct_Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION
GO
